Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 4269 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 433.7 KiB |
| Average record size in memory | 104.0 B |
Variable types
| Numeric | 10 |
|---|---|
| Categorical | 3 |
income_annum is highly overall correlated with loan_amount and 4 other fields | High correlation |
loan_amount is highly overall correlated with income_annum and 4 other fields | High correlation |
cibil_score is highly overall correlated with loan_status | High correlation |
residential_assets_value is highly overall correlated with income_annum and 3 other fields | High correlation |
commercial_assets_value is highly overall correlated with income_annum and 3 other fields | High correlation |
luxury_assets_value is highly overall correlated with income_annum and 4 other fields | High correlation |
bank_asset_value is highly overall correlated with income_annum and 4 other fields | High correlation |
loan_status is highly overall correlated with cibil_score | High correlation |
loan_id is uniformly distributed | Uniform |
loan_id has unique values | Unique |
no_of_dependents has 712 (16.7%) zeros | Zeros |
residential_assets_value has 45 (1.1%) zeros | Zeros |
commercial_assets_value has 107 (2.5%) zeros | Zeros |
Reproduction
| Analysis started | 2023-08-01 19:20:25.550183 |
|---|---|
| Analysis finished | 2023-08-01 19:20:59.895308 |
| Duration | 34.35 seconds |
| Software version | ydata-profiling vv4.4.0 |
| Download configuration | config.json |
loan_id
Real number (ℝ)
UNIFORM UNIQUE
| Distinct | 4269 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2135 |
| Minimum | 1 |
|---|---|
| Maximum | 4269 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 214.4 |
| Q1 | 1068 |
| median | 2135 |
| Q3 | 3202 |
| 95-th percentile | 4055.6 |
| Maximum | 4269 |
| Range | 4268 |
| Interquartile range (IQR) | 2134 |
Descriptive statistics
| Standard deviation | 1232.4985 |
|---|---|
| Coefficient of variation (CV) | 0.57728266 |
| Kurtosis | -1.2 |
| Mean | 2135 |
| Median Absolute Deviation (MAD) | 1067 |
| Skewness | 0 |
| Sum | 9114315 |
| Variance | 1519052.5 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 2852 | 1 | < 0.1% |
| 2838 | 1 | < 0.1% |
| 2839 | 1 | < 0.1% |
| 2840 | 1 | < 0.1% |
| 2841 | 1 | < 0.1% |
| 2842 | 1 | < 0.1% |
| 2843 | 1 | < 0.1% |
| 2844 | 1 | < 0.1% |
| 2845 | 1 | < 0.1% |
| Other values (4259) | 4259 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 4269 | 1 | |
| 4268 | 1 | |
| 4267 | 1 | |
| 4266 | 1 | |
| 4265 | 1 | |
| 4264 | 1 | |
| 4263 | 1 | |
| 4262 | 1 | |
| 4261 | 1 | |
| 4260 | 1 |
no_of_dependents
Real number (ℝ)
ZEROS
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4987116 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 712 |
| Zeros (%) | 16.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.6959102 |
|---|---|
| Coefficient of variation (CV) | 0.67871383 |
| Kurtosis | -1.2569922 |
| Mean | 2.4987116 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.017970543 |
| Sum | 10667 |
| Variance | 2.8761113 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 4 | 752 | |
| 3 | 727 | |
| 0 | 712 | |
| 2 | 708 | |
| 1 | 697 | |
| 5 | 673 |
| Value | Count | Frequency (%) |
| 0 | 712 | |
| 1 | 697 | |
| 2 | 708 | |
| 3 | 727 | |
| 4 | 752 | |
| 5 | 673 |
| Value | Count | Frequency (%) |
| 5 | 673 | |
| 4 | 752 | |
| 3 | 727 | |
| 2 | 708 | |
| 1 | 697 | |
| 0 | 712 |
education
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 33.5 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 4269 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 2144 | |
| 1 | 2125 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 2144 | |
| 1 | 2125 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2144 | |
| 1 | 2125 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 4269 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 2144 | |
| 1 | 2125 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 4269 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 2144 | |
| 1 | 2125 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4269 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 2144 | |
| 1 | 2125 |
self_employed
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 33.5 KiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 4269 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 2150 | |
| 0 | 2119 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 2150 | |
| 0 | 2119 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 2150 | |
| 0 | 2119 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 4269 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 2150 | |
| 0 | 2119 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 4269 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 2150 | |
| 0 | 2119 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4269 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 2150 | |
| 0 | 2119 |
income_annum
Real number (ℝ)
HIGH CORRELATION
| Distinct | 98 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5059123.9 |
| Minimum | 200000 |
|---|---|
| Maximum | 9900000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.5 KiB |
Quantile statistics
| Minimum | 200000 |
|---|---|
| 5-th percentile | 600000 |
| Q1 | 2700000 |
| median | 5100000 |
| Q3 | 7500000 |
| 95-th percentile | 9400000 |
| Maximum | 9900000 |
| Range | 9700000 |
| Interquartile range (IQR) | 4800000 |
Descriptive statistics
| Standard deviation | 2806839.8 |
|---|---|
| Coefficient of variation (CV) | 0.55480749 |
| Kurtosis | -1.182729 |
| Mean | 5059123.9 |
| Median Absolute Deviation (MAD) | 2400000 |
| Skewness | -0.012814425 |
| Sum | 2.15974 × 1010 |
| Variance | 7.8783498 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 7000000 | 62 | 1.5% |
| 4100000 | 59 | 1.4% |
| 7600000 | 57 | 1.3% |
| 4700000 | 56 | 1.3% |
| 6900000 | 55 | 1.3% |
| 3200000 | 55 | 1.3% |
| 5300000 | 55 | 1.3% |
| 3900000 | 54 | 1.3% |
| 8000000 | 53 | 1.2% |
| 9000000 | 53 | 1.2% |
| Other values (88) | 3710 |
| Value | Count | Frequency (%) |
| 200000 | 42 | |
| 300000 | 51 | |
| 400000 | 35 | |
| 500000 | 46 | |
| 600000 | 49 | |
| 700000 | 45 | |
| 800000 | 41 | |
| 900000 | 39 | |
| 1000000 | 42 | |
| 1100000 | 45 |
| Value | Count | Frequency (%) |
| 9900000 | 35 | |
| 9800000 | 48 | |
| 9700000 | 40 | |
| 9600000 | 39 | |
| 9500000 | 40 | |
| 9400000 | 47 | |
| 9300000 | 33 | |
| 9200000 | 49 | |
| 9100000 | 40 | |
| 9000000 | 53 |
loan_amount
Real number (ℝ)
HIGH CORRELATION
| Distinct | 378 |
|---|---|
| Distinct (%) | 8.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15133450 |
| Minimum | 300000 |
|---|---|
| Maximum | 39500000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.5 KiB |
Quantile statistics
| Minimum | 300000 |
|---|---|
| 5-th percentile | 1800000 |
| Q1 | 7700000 |
| median | 14500000 |
| Q3 | 21500000 |
| 95-th percentile | 30900000 |
| Maximum | 39500000 |
| Range | 39200000 |
| Interquartile range (IQR) | 13800000 |
Descriptive statistics
| Standard deviation | 9043363 |
|---|---|
| Coefficient of variation (CV) | 0.59757443 |
| Kurtosis | -0.74367972 |
| Mean | 15133450 |
| Median Absolute Deviation (MAD) | 6900000 |
| Skewness | 0.30872388 |
| Sum | 6.46047 × 1010 |
| Variance | 8.1782414 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10600000 | 27 | 0.6% |
| 20000000 | 24 | 0.6% |
| 9400000 | 24 | 0.6% |
| 16800000 | 23 | 0.5% |
| 23900000 | 23 | 0.5% |
| 11500000 | 22 | 0.5% |
| 14100000 | 22 | 0.5% |
| 12500000 | 22 | 0.5% |
| 1800000 | 21 | 0.5% |
| 3200000 | 21 | 0.5% |
| Other values (368) | 4040 |
| Value | Count | Frequency (%) |
| 300000 | 6 | 0.1% |
| 400000 | 7 | 0.2% |
| 500000 | 16 | |
| 600000 | 13 | |
| 700000 | 15 | |
| 800000 | 15 | |
| 900000 | 12 | |
| 1000000 | 10 | |
| 1100000 | 18 | |
| 1200000 | 17 |
| Value | Count | Frequency (%) |
| 39500000 | 1 | < 0.1% |
| 38800000 | 1 | < 0.1% |
| 38700000 | 2 | |
| 38500000 | 1 | < 0.1% |
| 38400000 | 1 | < 0.1% |
| 38200000 | 3 | |
| 38000000 | 1 | < 0.1% |
| 37900000 | 2 | |
| 37800000 | 2 | |
| 37700000 | 1 | < 0.1% |
loan_term
Real number (ℝ)
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.900445 |
| Minimum | 2 |
|---|---|
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.5 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 6 |
| median | 10 |
| Q3 | 16 |
| 95-th percentile | 20 |
| Maximum | 20 |
| Range | 18 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 5.7091873 |
|---|---|
| Coefficient of variation (CV) | 0.52375726 |
| Kurtosis | -1.2208527 |
| Mean | 10.900445 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0.036358907 |
| Sum | 46534 |
| Variance | 32.594819 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 6 | 490 | |
| 12 | 456 | |
| 4 | 447 | |
| 10 | 436 | |
| 18 | 422 | |
| 16 | 412 | |
| 20 | 411 | |
| 14 | 405 | |
| 2 | 404 | |
| 8 | 386 |
| Value | Count | Frequency (%) |
| 2 | 404 | |
| 4 | 447 | |
| 6 | 490 | |
| 8 | 386 | |
| 10 | 436 | |
| 12 | 456 | |
| 14 | 405 | |
| 16 | 412 | |
| 18 | 422 | |
| 20 | 411 |
| Value | Count | Frequency (%) |
| 20 | 411 | |
| 18 | 422 | |
| 16 | 412 | |
| 14 | 405 | |
| 12 | 456 | |
| 10 | 436 | |
| 8 | 386 | |
| 6 | 490 | |
| 4 | 447 | |
| 2 | 404 |
cibil_score
Real number (ℝ)
HIGH CORRELATION
| Distinct | 601 |
|---|---|
| Distinct (%) | 14.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 599.93605 |
| Minimum | 300 |
|---|---|
| Maximum | 900 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.5 KiB |
Quantile statistics
| Minimum | 300 |
|---|---|
| 5-th percentile | 330 |
| Q1 | 453 |
| median | 600 |
| Q3 | 748 |
| 95-th percentile | 869 |
| Maximum | 900 |
| Range | 600 |
| Interquartile range (IQR) | 295 |
Descriptive statistics
| Standard deviation | 172.4304 |
|---|---|
| Coefficient of variation (CV) | 0.28741463 |
| Kurtosis | -1.1856696 |
| Mean | 599.93605 |
| Median Absolute Deviation (MAD) | 147 |
| Skewness | -0.0090392773 |
| Sum | 2561127 |
| Variance | 29732.243 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 348 | 16 | 0.4% |
| 543 | 15 | 0.4% |
| 538 | 15 | 0.4% |
| 778 | 14 | 0.3% |
| 509 | 14 | 0.3% |
| 439 | 14 | 0.3% |
| 415 | 14 | 0.3% |
| 819 | 14 | 0.3% |
| 865 | 13 | 0.3% |
| 802 | 13 | 0.3% |
| Other values (591) | 4127 |
| Value | Count | Frequency (%) |
| 300 | 11 | |
| 301 | 8 | |
| 302 | 13 | |
| 303 | 6 | |
| 304 | 8 | |
| 305 | 3 | 0.1% |
| 306 | 9 | |
| 307 | 8 | |
| 308 | 6 | |
| 309 | 6 |
| Value | Count | Frequency (%) |
| 900 | 6 | |
| 899 | 6 | |
| 898 | 5 | |
| 897 | 4 | 0.1% |
| 896 | 11 | |
| 895 | 11 | |
| 894 | 5 | |
| 893 | 2 | < 0.1% |
| 892 | 8 | |
| 891 | 8 |
residential_assets_value
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 278 |
|---|---|
| Distinct (%) | 6.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7472616.5 |
| Minimum | -100000 |
|---|---|
| Maximum | 29100000 |
| Zeros | 45 |
| Zeros (%) | 1.1% |
| Negative | 28 |
| Negative (%) | 0.7% |
| Memory size | 33.5 KiB |
Quantile statistics
| Minimum | -100000 |
|---|---|
| 5-th percentile | 300000 |
| Q1 | 2200000 |
| median | 5600000 |
| Q3 | 11300000 |
| 95-th percentile | 21260000 |
| Maximum | 29100000 |
| Range | 29200000 |
| Interquartile range (IQR) | 9100000 |
Descriptive statistics
| Standard deviation | 6503636.6 |
|---|---|
| Coefficient of variation (CV) | 0.87032923 |
| Kurtosis | 0.18473799 |
| Mean | 7472616.5 |
| Median Absolute Deviation (MAD) | 4100000 |
| Skewness | 0.9784506 |
| Sum | 3.19006 × 1010 |
| Variance | 4.2297289 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 400000 | 66 | 1.5% |
| 500000 | 63 | 1.5% |
| 100000 | 60 | 1.4% |
| 1000000 | 57 | 1.3% |
| 600000 | 56 | 1.3% |
| 1300000 | 55 | 1.3% |
| 700000 | 52 | 1.2% |
| 300000 | 52 | 1.2% |
| 3200000 | 50 | 1.2% |
| 200000 | 50 | 1.2% |
| Other values (268) | 3708 |
| Value | Count | Frequency (%) |
| -100000 | 28 | |
| 0 | 45 | |
| 100000 | 60 | |
| 200000 | 50 | |
| 300000 | 52 | |
| 400000 | 66 | |
| 500000 | 63 | |
| 600000 | 56 | |
| 700000 | 52 | |
| 800000 | 45 |
| Value | Count | Frequency (%) |
| 29100000 | 1 | |
| 28700000 | 1 | |
| 28500000 | 2 | |
| 28400000 | 1 | |
| 28300000 | 1 | |
| 28200000 | 2 | |
| 28000000 | 1 | |
| 27600000 | 2 | |
| 27500000 | 1 | |
| 27400000 | 1 |
commercial_assets_value
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 188 |
|---|---|
| Distinct (%) | 4.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4973155.3 |
| Minimum | 0 |
|---|---|
| Maximum | 19400000 |
| Zeros | 107 |
| Zeros (%) | 2.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 200000 |
| Q1 | 1300000 |
| median | 3700000 |
| Q3 | 7600000 |
| 95-th percentile | 13900000 |
| Maximum | 19400000 |
| Range | 19400000 |
| Interquartile range (IQR) | 6300000 |
Descriptive statistics
| Standard deviation | 4388966.1 |
|---|---|
| Coefficient of variation (CV) | 0.88253148 |
| Kurtosis | 0.1008126 |
| Mean | 4973155.3 |
| Median Absolute Deviation (MAD) | 2800000 |
| Skewness | 0.95779089 |
| Sum | 2.12304 × 1010 |
| Variance | 1.9263023 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 107 | 2.5% |
| 200000 | 101 | 2.4% |
| 100000 | 100 | 2.3% |
| 300000 | 90 | 2.1% |
| 500000 | 83 | 1.9% |
| 800000 | 76 | 1.8% |
| 700000 | 74 | 1.7% |
| 400000 | 71 | 1.7% |
| 600000 | 70 | 1.6% |
| 1000000 | 67 | 1.6% |
| Other values (178) | 3430 |
| Value | Count | Frequency (%) |
| 0 | 107 | |
| 100000 | 100 | |
| 200000 | 101 | |
| 300000 | 90 | |
| 400000 | 71 | |
| 500000 | 83 | |
| 600000 | 70 | |
| 700000 | 74 | |
| 800000 | 76 | |
| 900000 | 52 |
| Value | Count | Frequency (%) |
| 19400000 | 1 | < 0.1% |
| 19000000 | 3 | |
| 18900000 | 1 | < 0.1% |
| 18800000 | 2 | |
| 18700000 | 1 | < 0.1% |
| 18500000 | 4 | |
| 18400000 | 3 | |
| 18300000 | 1 | < 0.1% |
| 18200000 | 1 | < 0.1% |
| 17900000 | 3 |
luxury_assets_value
Real number (ℝ)
HIGH CORRELATION
| Distinct | 379 |
|---|---|
| Distinct (%) | 8.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15126306 |
| Minimum | 300000 |
|---|---|
| Maximum | 39200000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.5 KiB |
Quantile statistics
| Minimum | 300000 |
|---|---|
| 5-th percentile | 1900000 |
| Q1 | 7500000 |
| median | 14600000 |
| Q3 | 21700000 |
| 95-th percentile | 31300000 |
| Maximum | 39200000 |
| Range | 38900000 |
| Interquartile range (IQR) | 14200000 |
Descriptive statistics
| Standard deviation | 9103753.7 |
|---|---|
| Coefficient of variation (CV) | 0.6018491 |
| Kurtosis | -0.73805613 |
| Mean | 15126306 |
| Median Absolute Deviation (MAD) | 7100000 |
| Skewness | 0.3222075 |
| Sum | 6.45742 × 1010 |
| Variance | 8.2878331 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 6200000 | 26 | 0.6% |
| 2900000 | 26 | 0.6% |
| 20400000 | 26 | 0.6% |
| 12300000 | 24 | 0.6% |
| 12000000 | 24 | 0.6% |
| 14900000 | 24 | 0.6% |
| 7100000 | 23 | 0.5% |
| 17200000 | 23 | 0.5% |
| 14100000 | 22 | 0.5% |
| 9900000 | 22 | 0.5% |
| Other values (369) | 4029 |
| Value | Count | Frequency (%) |
| 300000 | 4 | 0.1% |
| 400000 | 10 | |
| 500000 | 14 | |
| 600000 | 14 | |
| 700000 | 14 | |
| 800000 | 16 | |
| 900000 | 13 | |
| 1000000 | 8 | |
| 1100000 | 19 | |
| 1200000 | 16 |
| Value | Count | Frequency (%) |
| 39200000 | 1 | < 0.1% |
| 39100000 | 1 | < 0.1% |
| 38600000 | 2 | < 0.1% |
| 38200000 | 4 | |
| 38100000 | 5 | |
| 38000000 | 1 | < 0.1% |
| 37900000 | 2 | < 0.1% |
| 37800000 | 2 | < 0.1% |
| 37700000 | 1 | < 0.1% |
| 37600000 | 2 | < 0.1% |
bank_asset_value
Real number (ℝ)
HIGH CORRELATION
| Distinct | 146 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4976692.4 |
| Minimum | 0 |
|---|---|
| Maximum | 14700000 |
| Zeros | 8 |
| Zeros (%) | 0.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 500000 |
| Q1 | 2300000 |
| median | 4600000 |
| Q3 | 7100000 |
| 95-th percentile | 11100000 |
| Maximum | 14700000 |
| Range | 14700000 |
| Interquartile range (IQR) | 4800000 |
Descriptive statistics
| Standard deviation | 3250185.3 |
|---|---|
| Coefficient of variation (CV) | 0.65308141 |
| Kurtosis | -0.39727743 |
| Mean | 4976692.4 |
| Median Absolute Deviation (MAD) | 2400000 |
| Skewness | 0.56072501 |
| Sum | 2.12455 × 1010 |
| Variance | 1.0563705 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1400000 | 63 | 1.5% |
| 4900000 | 63 | 1.5% |
| 3600000 | 63 | 1.5% |
| 4500000 | 61 | 1.4% |
| 1600000 | 60 | 1.4% |
| 5400000 | 59 | 1.4% |
| 900000 | 58 | 1.4% |
| 1300000 | 57 | 1.3% |
| 1500000 | 54 | 1.3% |
| 3400000 | 54 | 1.3% |
| Other values (136) | 3677 |
| Value | Count | Frequency (%) |
| 0 | 8 | 0.2% |
| 100000 | 31 | |
| 200000 | 54 | |
| 300000 | 50 | |
| 400000 | 50 | |
| 500000 | 40 | |
| 600000 | 50 | |
| 700000 | 42 | |
| 800000 | 39 | |
| 900000 | 58 |
| Value | Count | Frequency (%) |
| 14700000 | 2 | |
| 14600000 | 2 | |
| 14400000 | 1 | < 0.1% |
| 14300000 | 1 | < 0.1% |
| 14200000 | 2 | |
| 14100000 | 3 | |
| 14000000 | 3 | |
| 13900000 | 4 | |
| 13800000 | 2 | |
| 13700000 | 1 | < 0.1% |
loan_status
Categorical
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 33.5 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 4269 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 2656 | |
| 1 | 1613 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 2656 | |
| 1 | 1613 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2656 | |
| 1 | 1613 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 4269 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 2656 | |
| 1 | 1613 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 4269 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 2656 | |
| 1 | 1613 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4269 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 2656 | |
| 1 | 1613 |
| loan_id | no_of_dependents | income_annum | loan_amount | loan_term | cibil_score | residential_assets_value | commercial_assets_value | luxury_assets_value | bank_asset_value | education | self_employed | loan_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| loan_id | 1.000 | 0.006 | 0.013 | 0.012 | 0.010 | 0.016 | 0.026 | 0.021 | 0.001 | 0.015 | 0.000 | 0.012 | 0.038 |
| no_of_dependents | 0.006 | 1.000 | 0.007 | -0.001 | -0.020 | -0.010 | 0.012 | 0.004 | 0.005 | 0.013 | 0.000 | 0.024 | 0.000 |
| income_annum | 0.013 | 0.007 | 1.000 | 0.941 | 0.011 | -0.023 | 0.638 | 0.643 | 0.943 | 0.879 | 0.000 | 0.035 | 0.020 |
| loan_amount | 0.012 | -0.001 | 0.941 | 1.000 | 0.012 | -0.020 | 0.613 | 0.622 | 0.894 | 0.840 | 0.028 | 0.000 | 0.052 |
| loan_term | 0.010 | -0.020 | 0.011 | 0.012 | 1.000 | 0.008 | 0.003 | -0.001 | 0.008 | 0.014 | 0.000 | 0.039 | 0.184 |
| cibil_score | 0.016 | -0.010 | -0.023 | -0.020 | 0.008 | 1.000 | -0.031 | -0.001 | -0.030 | -0.020 | 0.000 | 0.000 | 0.875 |
| residential_assets_value | 0.026 | 0.012 | 0.638 | 0.613 | 0.003 | -0.031 | 1.000 | 0.448 | 0.613 | 0.569 | 0.000 | 0.000 | 0.016 |
| commercial_assets_value | 0.021 | 0.004 | 0.643 | 0.622 | -0.001 | -0.001 | 0.448 | 1.000 | 0.619 | 0.589 | 0.000 | 0.028 | 0.018 |
| luxury_assets_value | 0.001 | 0.005 | 0.943 | 0.894 | 0.008 | -0.030 | 0.613 | 0.619 | 1.000 | 0.836 | 0.014 | 0.000 | 0.040 |
| bank_asset_value | 0.015 | 0.013 | 0.879 | 0.840 | 0.014 | -0.020 | 0.569 | 0.589 | 0.836 | 1.000 | 0.000 | 0.000 | 0.000 |
| education | 0.000 | 0.000 | 0.000 | 0.028 | 0.000 | 0.000 | 0.000 | 0.000 | 0.014 | 0.000 | 1.000 | 0.017 | 0.000 |
| self_employed | 0.012 | 0.024 | 0.035 | 0.000 | 0.039 | 0.000 | 0.000 | 0.028 | 0.000 | 0.000 | 0.017 | 1.000 | 0.000 |
| loan_status | 0.038 | 0.000 | 0.020 | 0.052 | 0.184 | 0.875 | 0.016 | 0.018 | 0.040 | 0.000 | 0.000 | 0.000 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| loan_id | no_of_dependents | education | self_employed | income_annum | loan_amount | loan_term | cibil_score | residential_assets_value | commercial_assets_value | luxury_assets_value | bank_asset_value | loan_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 2 | 0 | 0 | 9600000 | 29900000 | 12 | 778 | 2400000 | 17600000 | 22700000 | 8000000 | 0 |
| 1 | 2 | 0 | 1 | 1 | 4100000 | 12200000 | 8 | 417 | 2700000 | 2200000 | 8800000 | 3300000 | 1 |
| 2 | 3 | 3 | 0 | 0 | 9100000 | 29700000 | 20 | 506 | 7100000 | 4500000 | 33300000 | 12800000 | 1 |
| 3 | 4 | 3 | 0 | 0 | 8200000 | 30700000 | 8 | 467 | 18200000 | 3300000 | 23300000 | 7900000 | 1 |
| 4 | 5 | 5 | 1 | 1 | 9800000 | 24200000 | 20 | 382 | 12400000 | 8200000 | 29400000 | 5000000 | 1 |
| 5 | 6 | 0 | 0 | 1 | 4800000 | 13500000 | 10 | 319 | 6800000 | 8300000 | 13700000 | 5100000 | 1 |
| 6 | 7 | 5 | 0 | 0 | 8700000 | 33000000 | 4 | 678 | 22500000 | 14800000 | 29200000 | 4300000 | 0 |
| 7 | 8 | 2 | 0 | 1 | 5700000 | 15000000 | 20 | 382 | 13200000 | 5700000 | 11800000 | 6000000 | 1 |
| 8 | 9 | 0 | 0 | 1 | 800000 | 2200000 | 20 | 782 | 1300000 | 800000 | 2800000 | 600000 | 0 |
| 9 | 10 | 5 | 1 | 0 | 1100000 | 4300000 | 10 | 388 | 3200000 | 1400000 | 3300000 | 1600000 | 1 |
| loan_id | no_of_dependents | education | self_employed | income_annum | loan_amount | loan_term | cibil_score | residential_assets_value | commercial_assets_value | luxury_assets_value | bank_asset_value | loan_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4259 | 4260 | 0 | 1 | 1 | 4500000 | 11500000 | 14 | 509 | 13400000 | 2300000 | 15400000 | 5900000 | 1 |
| 4260 | 4261 | 5 | 0 | 0 | 8800000 | 29300000 | 10 | 560 | 16800000 | 13900000 | 31100000 | 9900000 | 0 |
| 4261 | 4262 | 3 | 0 | 1 | 3000000 | 7500000 | 6 | 881 | 1400000 | 4500000 | 6100000 | 2300000 | 0 |
| 4262 | 4263 | 5 | 0 | 0 | 1300000 | 3000000 | 20 | 540 | 1000000 | 2300000 | 3200000 | 1900000 | 1 |
| 4263 | 4264 | 3 | 0 | 0 | 5000000 | 12700000 | 14 | 865 | 4700000 | 8100000 | 19500000 | 6300000 | 0 |
| 4264 | 4265 | 5 | 0 | 1 | 1000000 | 2300000 | 12 | 317 | 2800000 | 500000 | 3300000 | 800000 | 1 |
| 4265 | 4266 | 0 | 1 | 1 | 3300000 | 11300000 | 20 | 559 | 4200000 | 2900000 | 11000000 | 1900000 | 0 |
| 4266 | 4267 | 2 | 1 | 0 | 6500000 | 23900000 | 18 | 457 | 1200000 | 12400000 | 18100000 | 7300000 | 1 |
| 4267 | 4268 | 1 | 1 | 0 | 4100000 | 12800000 | 8 | 780 | 8200000 | 700000 | 14100000 | 5800000 | 0 |
| 4268 | 4269 | 1 | 0 | 0 | 9200000 | 29700000 | 10 | 607 | 17800000 | 11800000 | 35700000 | 12000000 | 0 |